Order Management System Environment Configuration

Purpose: This topic describes the setup required to configure a database connection for Order Management System.

DBConfig Properties File

Use the dbconfig.properties file on the application server to configure database connection settings for Order Management System. This file contains the database information required to connect to each Order Management System database.

When to update this file: The system updates this file automatically during the installation process. You will need to update this file if you change your database server, database name, or database login; otherwise, the information in this file should not be changed.

Location of file: This file is normally saved on the application server at domain/conf/jenasysproperties, where domain is the WebLogic domain directory for Order Management System.

To edit the file: You can review and update this file using a text editor. If you make any changes to the DBConfig Properties file, you must restart Order Management System before the changes take effect.

The settings in this file that you might wish to review or edit are explained below.

Setting	Description
environment	The name of the Order Management System database environment. Change this setting to the name of your Order Management System environment.
db.machine.name	The name of the database server where the Order Management System database is located.
db.url	The connection information used to connect to the Order Management System database: jdbc:oracle:thin:@//hostname.us.oracle.com:9999/servicename where: • hostname = The Hostname defined for the database connection. • 9999 = The port used to connect to the database. • servicename = The Service name defined for the database connection.
db.user.name	The user ID used to connect to the Order Management System database server. This should be ORDER_MANAGEMENT.
db.password	The user’s database password used to connect to the Order Management System database server. The password entry here is encrypted. If you change the database password as part of your security standards, you must change this value and then restart Order Management System. Contact your Order Management System representative for instructions.